#!/usr/bin/env python
# -*- coding: utf-8 -*-

class CommodityFutureHourDataConfig:
    """
    计算commodity_future_hour_data表的基础数据
    """

    ################################ 调用myquant接口获取期货1小时级别数据 #############################
    # 调用myquant接口获取期货1小时级别数据，频率tick，15s, 30s, 60s, 300s, 900s, 1800s, 3600s
    Commodity_Future_Hour_Data_Basic_Data_Frequency = '3600s'
    # 调用myquant接口获取期货1小时级别数据，开始时间
    # Commodity_Future_Hour_Data_Basic_Data_Begin_Time = '2025-01-01 00:00:00'
    Commodity_Future_Hour_Data_Basic_Data_Begin_Time = '2025-11-27 21:00:00'
    # 调用myquant接口获取期货1小时级别数据，结束时间
    # Commodity_Future_Hour_Data_Basic_Data_End_Time = '2025-03-31 21:00:00'
    Commodity_Future_Hour_Data_Basic_Data_End_Time = '2025-11-28 21:00:00'
    # 调用myquant接口获取期货1小时级别数据，字段
    Commodity_Future_Hour_Data_Basic_Data_Fields = 'open, close, low, high, amount, volume, position, bob, eob'

    ######################### 计算commodity_future_hour_data表的基础数据 #######################
    # 计算1小时级别，某一个交易日，所有期货的last_close_price、rising_and_falling_amount和price_change字段
    Commodity_Future_Hour_Data_Basic_Data_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Basic_Data_By_End_Time = '2025-11-28 21:00:00'

    # 计算1小时级别，某一个交易日，所有期货的unite_relative_price_index字段
    Commodity_Future_Hour_Data_Unite_Relative_Price_Index_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Unite_Relative_Price_Index_By_End_Time = '2025-11-28 21:00:00'

    # 计算1小时级别，某一个交易日，所有期货的MA
    Commodity_Future_Hour_Data_Ma_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Ma_By_End_Time = '2025-11-28 21:00:00'

    # 计算1小时级别，某一个交易日，所有期货的MACD
    Commodity_Future_Hour_Data_Macd_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Macd_By_End_Time = '2025-11-28 21:00:00'

    # 计算1小时级别，某一个交易日，所有期货的KD
    Commodity_Future_Hour_Data_Kd_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Kd_By_End_Time = '2025-11-28 21:00:00'

    # 计算1小时级别，某一个交易日，所有期货的hei kin ashi
    Commodity_Future_Hour_Data_Hei_Kin_Ashi_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Hei_Kin_Ashi_By_End_Time = '2025-11-28 21:00:00'

    # 计算1小时级别，某一个交易日，所有期货的BOLL
    Commodity_Future_Hour_Data_Boll_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Boll_By_End_Time = '2025-11-28 21:00:00'

    # 计算1小时级别，某一个交易日，所有期货的BIAS
    Commodity_Future_Hour_Data_Bias_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Bias_By_End_Time = '2025-11-28 21:00:00'

    # 计算1小时级别，某一个交易日，所有期货的VARIANCE
    Commodity_Future_Hour_Data_Variance_By_Begin_Time = '2025-11-27 21:00:00'
    Commodity_Future_Hour_Data_Variance_By_End_Time = '2025-11-28 21:00:00'
